dblogshrink

Right-clickthedatabaseandselectTasks->Shrink->Files.Changethetypeto.Log.UnderShrinkaction,selectReleaseunusedspaceandclickOK.,2023年9月11日—ShrinkingalogfileremovesoneormoreVLFsthatholdnopartofthelogicallog(thatis,inactiveVLFs).Whenyoushrinkatransactionlog ...,2023年9月27日—ToshrinkadataorlogfileusingSSMS·InObjectExplorer,connecttoaninstanceoftheSQLServerDatabaseEngineandthenexpandthat ....

參考資訊如下
Truncate and shrink log files in SQL Server

Right-click the database and select Tasks -> Shrink -> Files. Change the type to. Log . Under Shrink action, select Release unused space and click OK.

Manage the size of the transaction log file

2023年9月11日 — Shrinking a log file removes one or more VLFs that hold no part of the logical log (that is, inactive VLFs). When you shrink a transaction log ...

Shrink a file

2023年9月27日 — To shrink a data or log file using SSMS · In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that ...

SQL Server LDF 容量大爆炸(SQL Server ldf truncate & shrink)

2021年3月10日 — Database. SQL Server LDF 容量大爆炸(SQL Server ldf truncate & shrink). 說明. 復原模式; Truncate Log file 清空交易紀錄檔; Shrink Log file 縮小 ...

sql

2014年9月30日 — I have a SQL Server 2008 database with a .mdf file with 1 GB and a .ldf file (log) with 70 GB. I really don't know what took my log ...

How to Shrink a Microsoft SQL Server Database ...

So we have a couple of different ways to shrink the log file. We can go into SQL Server Management Studio. go to the properties of the database and do the ...

Microsoft SQL Server Shrinking Database Transaction Log

2023年10月27日 — Use SQL Server Studio Management. Right click on the database with Transaction Log that needs shrinking. Select Tasks -> Shrink -> Files.

How to shrink the transaction log

On the Shrink File window, change the File Type to Log. You can also choose to either release unused space, reorganize pages before releasing unused space, or ...

How to shrink the transaction log file in SQL Server

2021年10月4日 — To shrink a data or log file using SQL Management Studio: In Object Explorer, connect to an instance of the SQL Server Database Engine and then ...